


using System;
using SubSonic.Schema;
using System.Collections.Generic;
using SubSonic.DataProviders;
using System.Data;

namespace SurveyTrackerV2 {
	
        /// <summary>
        /// Table: List
        /// Primary Key: ListId
        /// </summary>

        public class ListTable: DatabaseTable {
            
            public ListTable(IDataProvider provider):base("List",provider){
                ClassName = "List";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("ListId", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("ListName", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 255
                });

                Columns.Add(new DatabaseColumn("ListStatus", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }

            public IColumn ListId{
                get{
                    return this.GetColumn("ListId");
                }
            }
				
   			public static string ListIdColumn{
			      get{
        			return "ListId";
      			}
		    }
            
            public IColumn ListName{
                get{
                    return this.GetColumn("ListName");
                }
            }
				
   			public static string ListNameColumn{
			      get{
        			return "ListName";
      			}
		    }
            
            public IColumn ListStatus{
                get{
                    return this.GetColumn("ListStatus");
                }
            }
				
   			public static string ListStatusColumn{
			      get{
        			return "ListStatus";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: Email
        /// Primary Key: EmailId
        /// </summary>

        public class EmailTable: DatabaseTable {
            
            public EmailTable(IDataProvider provider):base("Email",provider){
                ClassName = "Email";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("EmailId", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("EmailAddress", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 255
                });

                Columns.Add(new DatabaseColumn("EmailStatus", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }

            public IColumn EmailId{
                get{
                    return this.GetColumn("EmailId");
                }
            }
				
   			public static string EmailIdColumn{
			      get{
        			return "EmailId";
      			}
		    }
            
            public IColumn EmailAddress{
                get{
                    return this.GetColumn("EmailAddress");
                }
            }
				
   			public static string EmailAddressColumn{
			      get{
        			return "EmailAddress";
      			}
		    }
            
            public IColumn EmailStatus{
                get{
                    return this.GetColumn("EmailStatus");
                }
            }
				
   			public static string EmailStatusColumn{
			      get{
        			return "EmailStatus";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: EmailList
        /// Primary Key: EmailListId
        /// </summary>

        public class EmailListTable: DatabaseTable {
            
            public EmailListTable(IDataProvider provider):base("EmailList",provider){
                ClassName = "EmailList";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("EmailListId", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("EmailId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("ListId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("EmailListStatus", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }

            public IColumn EmailListId{
                get{
                    return this.GetColumn("EmailListId");
                }
            }
				
   			public static string EmailListIdColumn{
			      get{
        			return "EmailListId";
      			}
		    }
            
            public IColumn EmailId{
                get{
                    return this.GetColumn("EmailId");
                }
            }
				
   			public static string EmailIdColumn{
			      get{
        			return "EmailId";
      			}
		    }
            
            public IColumn ListId{
                get{
                    return this.GetColumn("ListId");
                }
            }
				
   			public static string ListIdColumn{
			      get{
        			return "ListId";
      			}
		    }
            
            public IColumn EmailListStatus{
                get{
                    return this.GetColumn("EmailListStatus");
                }
            }
				
   			public static string EmailListStatusColumn{
			      get{
        			return "EmailListStatus";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: Mailing
        /// Primary Key: MailingId
        /// </summary>

        public class MailingTable: DatabaseTable {
            
            public MailingTable(IDataProvider provider):base("Mailing",provider){
                ClassName = "Mailing";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("MailingId", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("MailingSubject", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 255
                });

                Columns.Add(new DatabaseColumn("EmailListId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("MailingMessage", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 2147483647
                });

                Columns.Add(new DatabaseColumn("MailingFromEmail", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 255
                });

                Columns.Add(new DatabaseColumn("MailingFromName", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 255
                });

                Columns.Add(new DatabaseColumn("MailingLink", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 255
                });

                Columns.Add(new DatabaseColumn("MailingDate", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }

            public IColumn MailingId{
                get{
                    return this.GetColumn("MailingId");
                }
            }
				
   			public static string MailingIdColumn{
			      get{
        			return "MailingId";
      			}
		    }
            
            public IColumn MailingSubject{
                get{
                    return this.GetColumn("MailingSubject");
                }
            }
				
   			public static string MailingSubjectColumn{
			      get{
        			return "MailingSubject";
      			}
		    }
            
            public IColumn EmailListId{
                get{
                    return this.GetColumn("EmailListId");
                }
            }
				
   			public static string EmailListIdColumn{
			      get{
        			return "EmailListId";
      			}
		    }
            
            public IColumn MailingMessage{
                get{
                    return this.GetColumn("MailingMessage");
                }
            }
				
   			public static string MailingMessageColumn{
			      get{
        			return "MailingMessage";
      			}
		    }
            
            public IColumn MailingFromEmail{
                get{
                    return this.GetColumn("MailingFromEmail");
                }
            }
				
   			public static string MailingFromEmailColumn{
			      get{
        			return "MailingFromEmail";
      			}
		    }
            
            public IColumn MailingFromName{
                get{
                    return this.GetColumn("MailingFromName");
                }
            }
				
   			public static string MailingFromNameColumn{
			      get{
        			return "MailingFromName";
      			}
		    }
            
            public IColumn MailingLink{
                get{
                    return this.GetColumn("MailingLink");
                }
            }
				
   			public static string MailingLinkColumn{
			      get{
        			return "MailingLink";
      			}
		    }
            
            public IColumn MailingDate{
                get{
                    return this.GetColumn("MailingDate");
                }
            }
				
   			public static string MailingDateColumn{
			      get{
        			return "MailingDate";
      			}
		    }
            
                    
        }
        
}